| AdFees |
| Logical Entity Name | AdFees |
| Default Table Name | AdFees |
| Physical Only | NO |
| Definition | |
| Note |
| AdFees Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
AdEnrollID |
int | NO | ||
| SyStudentID | int | NO | ||
| SaBillCodeID | int | NO | ||
| AcadYear | numeric(3, 0) | NO | ||
| Descrip | varchar(35) | NO | ||
| ModFlag | char(1) | NO | ||
| Amount | money | NO | ||
| OneTimeFee | bit | NO | ||
| UserID | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
AdFeesID |
int | NO | ||
| AdTermID | int | YES | ||
| Billed | bit | NO | ||
| TermSequence | numeric(9, 0) | NO | ||
| RevenueUnits | money | YES | ||
| Offset | int | YES | ||
| AdProgramFeeId | int | YES |
| AdFees Primary and Unique Keys |
| Key Name | Key Type | Keys |
| AdFees_AdEnrollID_AdTermID_SaBillCodeID_AdFeesID_U_N_IDX | Index | AdEnrollID, AdTermID, SaBillCodeID, AdFeesID |
| AdFees_AdEnrollID_Amount_Billed_AdFeesId_AdTermId_U_N_IDX | Index | AdEnrollID, Amount, Billed, AdFeesID, AdTermID |
| AdFees_AdFeesID_U_C_IDX | PrimaryKey | AdFeesID |
| AdFees Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdEnroll | Non-Identifying | One To Zero or More | FK_AdFees_AdEnrollID_AdEnroll_AdEnrollID | AdEnrollID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaAutoBillBatchDetail | Non-Identifying | One To Zero or More | FK_SaAutoBillBatchDetail_AdFeesID_AdFees_AdFeesID | NO | YES | |||
| SaEnrollRevenue | Non-Identifying | One To Zero or More | FK_SaEnrollRevenue_AdFeesId_AdFees_AdFeesId | NO | YES | |||
| SaPendingCharge | Non-Identifying | One To Zero or More | Fk_SaPendingCharge_AdFeesID_AdFees_AdFeesID | NO | YES | |||
| SaTrans | Non-Identifying | One To Zero or More | FK_SaTrans_AdFeesId_AdFees_AdFeesId | NO | YES |
| AdFees Check Constraints |
| Check Constraint Name | CheckConstraint |